SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DnnProduct_CDS_PermissionsAdd]
	@TemplateID int,
	@PermissionType tinyint,
	@Scope tinyint
AS
BEGIN
	INSERT INTO [DnnProduct_CDS_Permissions] (TemplateID, PermissionType, Scope)
	VALUES (@TemplateID, @PermissionType, @Scope)

	SELECT SCOPE_IDENTITY()
END
GO
